Sell-out Report

Dataset statistics

Number of variables	19
Number of observations	4254339
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.5 GiB
Average record size in memory	895.0 B

Variable types

Numeric	6
DateTime	1
Categorical	12

Alerts

`store_name` has a high cardinality: 2257 distinct values	High cardinality
`deposit/distributor` has a high cardinality: 77 distinct values	High cardinality
`municipality/city` has a high cardinality: 606 distinct values	High cardinality
`units` is highly correlated with `total`	High correlation
`total` is highly correlated with `units`	High correlation
`units` is highly correlated with `total`	High correlation
`total` is highly correlated with `units`	High correlation
`units` is highly correlated with `total`	High correlation
`total` is highly correlated with `units`	High correlation
`division` is highly correlated with `grade` and 3 other fields	High correlation
`sku_subcategory` is highly correlated with `sku_description` and 1 other fields	High correlation
`format` is highly correlated with `supplier`	High correlation
`grade` is highly correlated with `division` and 3 other fields	High correlation
`supplier` is highly correlated with `format` and 1 other fields	High correlation
`sku_description` is highly correlated with `sku_subcategory` and 2 other fields	High correlation
`state` is highly correlated with `division` and 3 other fields	High correlation
`structure` is highly correlated with `division` and 3 other fields	High correlation
`sku_category` is highly correlated with `sku_subcategory` and 1 other fields	High correlation
`deposit/distributor` is highly correlated with `division` and 3 other fields	High correlation
`id` is highly correlated with `store_id` and 3 other fields	High correlation
`store_id` is highly correlated with `id` and 3 other fields	High correlation
`format` is highly correlated with `id` and 6 other fields	High correlation
`structure` is highly correlated with `format` and 4 other fields	High correlation
`division` is highly correlated with `structure` and 3 other fields	High correlation
`deposit/distributor` is highly correlated with `store_id` and 5 other fields	High correlation
`state` is highly correlated with `format` and 4 other fields	High correlation
`supplier` is highly correlated with `id` and 3 other fields	High correlation
`grade` is highly correlated with `structure` and 3 other fields	High correlation
`sku` is highly correlated with `sku_description` and 3 other fields	High correlation
`sku_description` is highly correlated with `id` and 7 other fields	High correlation
`sku_category` is highly correlated with `sku` and 3 other fields	High correlation
`sku_subcategory` is highly correlated with `sku` and 3 other fields	High correlation
`units` is highly correlated with `unit_price` and 1 other fields	High correlation
`unit_price` is highly correlated with `sku` and 5 other fields	High correlation
`total` is highly correlated with `sku_description` and 2 other fields	High correlation
`id` has unique values	Unique

Reproduction

Analysis started	2021-10-17 15:56:36.295369
Analysis finished	2021-10-17 16:00:51.770806
Duration	4 minutes and 15.48 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	4254339
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2638617.371

Minimum	0
Maximum	5489595
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	48.7 MiB

Quantile statistics

Minimum	0
5-th percentile	259874.9
Q1	1310655.5
median	2627263
Q3	3950203
95-th percentile	5081388.4
Maximum	5489595
Range	5489595
Interquartile range (IQR)	2639547.5

Descriptive statistics

Standard deviation	1537052.559
Coefficient of variation (CV)	0.5825219585
Kurtosis	-1.164308021
Mean	2638617.371
Median Absolute Deviation (MAD)	1319790
Skewness	0.03271820983
Sum	1.122557279 × 10¹³
Variance	2.362530568 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4196351	1	< 0.1%
4677055	1	< 0.1%
374242	1	< 0.1%
370144	1	< 0.1%
4480479	1	< 0.1%
284126	1	< 0.1%
4488667	1	< 0.1%
292314	1	< 0.1%
4484569	1	< 0.1%
4464087	1	< 0.1%
Other values (4254329)	4254329	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5489595	1	< 0.1%
5489587	1	< 0.1%
5489584	1	< 0.1%
5489580	1	< 0.1%
5489577	1	< 0.1%
5489573	1	< 0.1%
5489571	1	< 0.1%
5489570	1	< 0.1%
5489564	1	< 0.1%
5489557	1	< 0.1%

date
Date

Distinct	397
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	64.9 MiB

Minimum	2016-01-01 00:00:00
Maximum	2017-06-04 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

store_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2311
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2636.168118

Minimum	2
Maximum	5855
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	64.9 MiB

Quantile statistics

Minimum	2
5-th percentile	239
Q1	1661
median	2676
Q3	3703
95-th percentile	5440
Maximum	5855
Range	5853
Interquartile range (IQR)	2042

Descriptive statistics

Standard deviation	1330.483814
Coefficient of variation (CV)	0.504703704
Kurtosis	-0.257816153
Mean	2636.168118
Median Absolute Deviation (MAD)	1020
Skewness	0.1858588328
Sum	1.121515284 × 10¹⁰
Variance	1770187.178
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1003	4460	0.1%
1016	4201	0.1%
3747	4195	0.1%
1770	4152	0.1%
2384	4128	0.1%
1084	4116	0.1%
3505	4109	0.1%
3895	4055	0.1%
4073	4045	0.1%
3847	4044	0.1%
Other values (2301)	4212834	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1800	< 0.1%
4	1111	< 0.1%
5	1585	< 0.1%
6	1092	< 0.1%
7	1149	< 0.1%
8	1099	< 0.1%
9	1381	< 0.1%
10	1287	< 0.1%
11	1064	< 0.1%
12	1566	< 0.1%

Value	Count	Frequency (%)
5855	3433	0.1%
5851	2866	0.1%
5850	2889	0.1%
5844	2619	0.1%
5843	3221	0.1%
5827	3211	0.1%
5825	3646	0.1%
5817	3387	0.1%
5815	3544	0.1%
5813	2701	0.1%

format
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.9 MiB

Grocery	1202193
AllInOne	1147815
Leftorium	814123
SmallShop	430472
GipsyTrade	315696
Other values (4)	344040

Length

Max length	10
Median length	8
Mean length	7.925143248
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Grocery
2nd row	AllInOne
3rd row	AllInOne
4th row	Leftorium
5th row	Grocery

Common Values

Value	Count	Frequency (%)
Grocery	1202193	28.3%
AllInOne	1147815	27.0%
Leftorium	814123	19.1%
SmallShop	430472	10.1%
GipsyTrade	315696	7.4%
Shop	263019	6.2%
GreatShop	68538	1.6%
TinyShop	8122	0.2%
BigCom	4361	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
grocery	1202193	28.3%
allinone	1147815	27.0%
leftorium	814123	19.1%
smallshop	430472	10.1%
gipsytrade	315696	7.4%
shop	263019	6.2%
greatshop	68538	1.6%
tinyshop	8122	0.2%
bigcom	4361	0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

store_name
Categorical

HIGH CARDINALITY

Distinct	2257
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	349.7 MiB

Bizarre Crimson Fishmonger	6596
Bloody Chocolate AllInOne	6305
Enlightened Cyan HairDresser	5854
Enlightened Lavender GipsyTrade	5755
Bad Sky Blue Mall	5580
Other values (2252)	4224249

Length

Max length	33
Median length	21
Mean length	21.19869127
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Old Indigo BigCom
2nd row	Dead Burgundy Shop
3rd row	Kicking Orange HairDresser
4th row	Funny Maroon LunchHall
5th row	Defiant Red Mall

Common Values

Value	Count	Frequency (%)
Bizarre Crimson Fishmonger	6596	0.2%
Bloody Chocolate AllInOne	6305	0.1%
Enlightened Cyan HairDresser	5854	0.1%
Enlightened Lavender GipsyTrade	5755	0.1%
Bad Sky Blue Mall	5580	0.1%
Defiant Orange Butcher	5480	0.1%
Awesome Lemon BookShop	5416	0.1%
Kicking Brown Convenience	5294	0.1%
Short Olive BigCom	5291	0.1%
Horrible Black Leftorium	5086	0.1%
Other values (2247)	4197682	98.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
green	233923	1.8%
blue	225298	1.7%
shop	158409	1.2%
stationer	156755	1.2%
fishmonger	153940	1.2%
market	153812	1.2%
butcher	149862	1.2%
deli	148909	1.2%
grocery	147076	1.1%
baker	145027	1.1%
Other values (102)	11232126	87.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

structure
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	294.7 MiB

FORANEO	2013950
METRO	1441487
DISTRIBUIDORES	798902

Length

Max length	14
Median length	7
Mean length	7.636841587
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FORANEO
2nd row	DISTRIBUIDORES
3rd row	FORANEO
4th row	FORANEO
5th row	METRO

Common Values

Value	Count	Frequency (%)
FORANEO	2013950	47.3%
METRO	1441487	33.9%
DISTRIBUIDORES	798902	18.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
foraneo	2013950	47.3%
metro	1441487	33.9%
distribuidores	798902	18.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

division
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	318.7 MiB

METRO-NORTE	773808
METRO-SUR	667679
CENTRO	531307
BAJÍO	481556
OCCIDENTE	407709
Other values (6)	1392280

Length

Max length	11
Median length	9
Mean length	8.216916894
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CENTRO
2nd row	CENTRO
3rd row	CENTRO-SUR
4th row	CENTRO
5th row	METRO-NORTE

Common Values

Value	Count	Frequency (%)
METRO-NORTE	773808	18.2%
METRO-SUR	667679	15.7%
CENTRO	531307	12.5%
BAJÍO	481556	11.3%
OCCIDENTE	407709	9.6%
SURESTE	362945	8.5%
NORESTE	276112	6.5%
CENTRO-SUR	225405	5.3%
PENÍNSULA	221555	5.2%
NOROESTE	183196	4.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
metro-norte	773808	18.2%
metro-sur	667679	15.7%
centro	531307	12.5%
bajío	481556	11.3%
occidente	407709	9.6%
sureste	362945	8.5%
noreste	276112	6.5%
centro-sur	225405	5.3%
península	221555	5.2%
noroeste	183196	4.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

deposit/distributor
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	77
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	337.6 MiB

Emolor Vocals	347313
Colorvit Ifonforge Industries	202871
Lorthogus Toughworks	198650
Thrilthoal Empire	182213
Thrilmamad Vocals	162288
Other values (72)	3161004

Length

Max length	32
Median length	17
Mean length	18.2180059
Min length	12

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Vitena Vocals
2nd row	Movitalf Empire
3rd row	Gorngusco Toughworks
4th row	Elortho Aerospace
5th row	Marvitrus Ifonforge Industries

Common Values

Value	Count	Frequency (%)
Emolor Vocals	347313	8.2%
Colorvit Ifonforge Industries	202871	4.8%
Lorthogus Toughworks	198650	4.7%
Thrilthoal Empire	182213	4.3%
Thrilmamad Vocals	162288	3.8%
Thrilvitar Industrail	153234	3.6%
Ioalfio Ifonforge Industries	149574	3.5%
Thrilvallor Corp.	135984	3.2%
Elortho Aerospace	128190	3.0%
Barrusgul Corp.	113824	2.7%
Other values (67)	2480198	58.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
vocals	1017026	11.1%
ifonforge	665559	7.3%
industries	665559	7.3%
corp	546994	6.0%
industrail	518874	5.7%
toughworks	427009	4.7%
emolor	347313	3.8%
empire	344638	3.8%
inc	307644	3.4%
aerospace	291461	3.2%
Other values (76)	4042160	44.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

state
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	32
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	296.8 MiB

Alloralf	958488
Magornmar	675352
Thrilvallor	230976
Coalmar	225968
Barthovit	222572
Other values (27)	1940983

Length

Max length	11
Median length	8
Mean length	8.146733723
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Thrilvallor
2nd row	Alloralf
3rd row	Lorgulgus
4th row	Alloralf
5th row	Magornmar

Common Values

Value	Count	Frequency (%)
Alloralf	958488	22.5%
Magornmar	675352	15.9%
Thrilvallor	230976	5.4%
Coalmar	225968	5.3%
Barthovit	222572	5.2%
Erodmo	201881	4.7%
Nabargus	198445	4.7%
Alfrusma	156322	3.7%
Lorvalmo	127892	3.0%
Lorgulgus	118347	2.8%
Other values (22)	1138096	26.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
alloralf	958488	22.5%
magornmar	675352	15.9%
thrilvallor	230976	5.4%
coalmar	225968	5.3%
barthovit	222572	5.2%
erodmo	201881	4.7%
nabargus	198445	4.7%
alfrusma	156322	3.7%
lorvalmo	127892	3.0%
lorgulgus	118347	2.8%
Other values (22)	1138096	26.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

municipality/city
Categorical

HIGH CARDINALITY

Distinct	606
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	341.5 MiB

Enlightened Dark Empire	631506
Purple Creek	143626
Evil Chocolate Rock	107966
Empty Chartreuse Butter	90343
First Salmon Rock	81053
Other values (601)	3199845

Length

Max length	29
Median length	19
Mean length	19.17095887
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Purple Creek
2nd row	Long Chocolate Barrier
3rd row	Horrible Purple Tree
4th row	Funny Magenta Tree
5th row	Enlightened Dark Empire

Common Values

Value	Count	Frequency (%)
Enlightened Dark Empire	631506	14.8%
Purple Creek	143626	3.4%
Evil Chocolate Rock	107966	2.5%
Empty Chartreuse Butter	90343	2.1%
First Salmon Rock	81053	1.9%
Evil Azure Metropolis	71587	1.7%
Long Lavender Butter	70285	1.7%
Last Pink River	69073	1.6%
Singing Grey Empire	66939	1.6%
Little Silver Polis	66320	1.6%
Other values (596)	2855641	67.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
empire	792838	6.3%
dark	691450	5.5%
enlightened	683419	5.4%
chocolate	305671	2.4%
rock	292359	2.3%
evil	285560	2.3%
purple	236317	1.9%
chartreuse	232293	1.8%
rare	206077	1.6%
butter	200182	1.6%
Other values (108)	8684380	68.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

supplier
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	308.4 MiB

proveedor_2	3922782
proveedor_1	331557

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	proveedor_2
2nd row	proveedor_2
3rd row	proveedor_2
4th row	proveedor_2
5th row	proveedor_2

Common Values

Value	Count	Frequency (%)
proveedor_2	3922782	92.2%
proveedor_1	331557	7.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
proveedor_2	3922782	92.2%
proveedor_1	331557	7.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

grade
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	271.7 MiB

IV	1644414
V	675352
VI	659255
III	647166
II	529689

Length

Max length	3
Median length	2
Mean length	1.970230628
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IV
2nd row	IV
3rd row	IV
4th row	IV
5th row	V

Common Values

Value	Count	Frequency (%)
IV	1644414	38.7%
V	675352	15.9%
VI	659255	15.5%
III	647166	15.2%
II	529689	12.5%
I	98463	2.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
iv	1644414	38.7%
v	675352	15.9%
vi	659255	15.5%
iii	647166	15.2%
ii	529689	12.5%
i	98463	2.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

sku
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	46
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4455742.654

Minimum	4220015
Maximum	4829827
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	64.9 MiB

Quantile statistics

Minimum	4220015
5-th percentile	4240039
Q1	4290336
median	4442378
Q3	4615034
95-th percentile	4665676
Maximum	4829827
Range	609812
Interquartile range (IQR)	324698

Descriptive statistics

Standard deviation	155313.5231
Coefficient of variation (CV)	0.03485693297
Kurtosis	-1.330780289
Mean	4455742.654
Median Absolute Deviation (MAD)	152042
Skewness	0.08813030507
Sum	1.895623975 × 10¹³
Variance	2.412229044 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
4554143	289770	6.8%
4270121	288587	6.8%
4240039	285323	6.7%
4330800	276087	6.5%
4381425	273462	6.4%
4290336	260236	6.1%
4442378	254123	6.0%
4250046	252974	5.9%
4412040	238867	5.6%
4533931	207049	4.9%
Other values (36)	1627861	38.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4220015	7100	0.2%
4230022	9114	0.2%
4240039	285323	6.7%
4250046	252974	5.9%
4260053	32516	0.8%
4270121	288587	6.8%
4290336	260236	6.1%
4300343	3	< 0.1%
4330800	276087	6.5%
4351043	8059	0.2%

Value	Count	Frequency (%)
4829827	7209	0.2%
4819810	9482	0.2%
4809797	8790	0.2%
4789544	64	< 0.1%
4779537	32	< 0.1%
4769520	36	< 0.1%
4759438	4	< 0.1%
4749421	21	< 0.1%
4739414	14	< 0.1%
4729193	29589	0.7%

sku_description
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	46
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	346.8 MiB

Stars Mango Peach	289770
Squares Chocolate	288587
Lucjy Charms Chocolate	285323
Crunch Mango Peach	276087
Chocos Mango Peach	273462
Other values (41)	2841110

Length

Max length	42
Median length	18
Mean length	20.47953348
Min length	15

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cups Mango Peach
2nd row	Cups Mango Peach
3rd row	Cups Mango Peach
4th row	Cups Mango Peach
5th row	Cups Mango Peach

Common Values

Value	Count	Frequency (%)
Stars Mango Peach	289770	6.8%
Squares Chocolate	288587	6.8%
Lucjy Charms Chocolate	285323	6.7%
Crunch Mango Peach	276087	6.5%
Chocos Mango Peach	273462	6.4%
Toast Chocolate	260236	6.1%
Crunchy Bran Mango Peach	254123	6.0%
Muesli Chocolate	252974	5.9%
Crispy Rice Mango Peach	238867	5.6%
Cups Mango Peach	207049	4.9%
Other values (36)	1627861	38.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mango	2408661	17.9%
peach	2408661	17.9%
chocolate	1845678	13.7%
choc	709828	5.3%
chip	709828	5.3%
crunch	510234	3.8%
toast	450667	3.4%
squares	416108	3.1%
stars	296870	2.2%
chocos	295026	2.2%
Other values (31)	3373946	25.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

sku_category
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	308.6 MiB

Sugar-free	2741950
Super-flavour	1512389

Length

Max length	13
Median length	10
Mean length	11.06647989
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Super-flavour
2nd row	Super-flavour
3rd row	Super-flavour
4th row	Super-flavour
5th row	Super-flavour

Common Values

Value	Count	Frequency (%)
Sugar-free	2741950	64.5%
Super-flavour	1512389	35.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
sugar-free	2741950	64.5%
super-flavour	1512389	35.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

sku_subcategory
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	306.9 MiB

Cereal bars	2741950
Cereal box	1512389

Length

Max length	11
Median length	11
Mean length	10.6445067
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cereal box
2nd row	Cereal box
3rd row	Cereal box
4th row	Cereal box
5th row	Cereal box

Common Values

Value	Count	Frequency (%)
Cereal bars	2741950	64.5%
Cereal box	1512389	35.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
cereal	4254339	50.0%
bars	2741950	32.2%
box	1512389	17.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

units
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	352
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.471704587

Minimum	0.2
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	64.9 MiB

Quantile statistics

Minimum	0.2
5-th percentile	0.25
Q1	1
median	3
Q3	9
95-th percentile	25
Maximum	36
Range	35.8
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	7.975320511
Coefficient of variation (CV)	1.232336922
Kurtosis	2.32100284
Mean	6.471704587
Median Absolute Deviation (MAD)	2.4
Skewness	1.726872008
Sum	27532825.22
Variance	63.60573726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	373963	8.8%
2	280259	6.6%
3	202443	4.8%
0.2	169183	4.0%
4	164160	3.9%
0.45	134102	3.2%
5	130206	3.1%
6	115734	2.7%
0.25	112142	2.6%
0.4	108804	2.6%
Other values (342)	2463343	57.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.2	169183	4.0%
0.25	112142	2.6%
0.4	108804	2.6%
0.45	134102	3.2%
0.5	93402	2.2%
0.6	70646	1.7%
0.75	64999	1.5%
0.8	48900	1.1%
0.9	87473	2.1%
1	373963	8.8%

Value	Count	Frequency (%)
36	10291	0.2%
35.91	135	< 0.1%
35.8	14	< 0.1%
35.75	89	< 0.1%
35.6	7	< 0.1%
35.55	27	< 0.1%
35.5	65	< 0.1%
35.4	13	< 0.1%
35.25	86	< 0.1%
35.2	15	< 0.1%

unit_price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	3123
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.48734904

Minimum	1
Maximum	28.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	64.9 MiB

Quantile statistics

Minimum	1
5-th percentile	5.17
Q1	10.1
median	16
Q3	17.6
95-th percentile	22.6
Maximum	28.2
Range	27.2
Interquartile range (IQR)	7.5

Descriptive statistics

Standard deviation	5.193937571
Coefficient of variation (CV)	0.3585153887
Kurtosis	-0.729426986
Mean	14.48734904
Median Absolute Deviation (MAD)	3.6
Skewness	-0.1557830016
Sum	61634094.02
Variance	26.97698749
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	255916	6.0%
9.7	242760	5.7%
17.5	213090	5.0%
5	198554	4.7%
21.5	193607	4.6%
17.6	170888	4.0%
16.4	155741	3.7%
18	145508	3.4%
16.8	122287	2.9%
10.2	117760	2.8%
Other values (3113)	2438228	57.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	< 0.1%
1.03	1	< 0.1%
1.111111111	8	< 0.1%
1.13	1	< 0.1%
1.2	1	< 0.1%
1.21	1	< 0.1%
1.25	4	< 0.1%
1.35	1	< 0.1%
1.4	5	< 0.1%
1.402116402	1	< 0.1%

Value	Count	Frequency (%)
28.2	89	< 0.1%
28.16	10	< 0.1%
28.14	2	< 0.1%
28.13	1	< 0.1%
28.12	7	< 0.1%
28.11	1	< 0.1%
28.08	11	< 0.1%
28.07	3	< 0.1%
28.06666667	1	< 0.1%
28.05	2	< 0.1%

total
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	52949
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	99.1939017

Minimum	0.3
Maximum	611.226
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	64.9 MiB

Quantile statistics

Minimum	0.3
5-th percentile	2.1
Q1	13.35
median	41.6
Q3	135.45
95-th percentile	397.6
Maximum	611.226
Range	610.926
Interquartile range (IQR)	122.1

Descriptive statistics

Standard deviation	127.3468747
Coefficient of variation (CV)	1.283817579
Kurtosis	2.602744921
Mean	99.1939017
Median Absolute Deviation (MAD)	35.78
Skewness	1.779073244
Sum	422004484.6
Variance	16217.2265
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.94	66014	1.6%
9.675	50899	1.2%
3.88	40662	1.0%
2.04	37575	0.9%
1.25	36944	0.9%
17.6	35283	0.8%
16	35064	0.8%
16.4	34516	0.8%
17.5	31718	0.7%
18	30714	0.7%
Other values (52939)	3854950	90.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.3	1	< 0.1%
0.38	1	< 0.1%
0.5	3	< 0.1%
0.55	1	< 0.1%
0.6	2	< 0.1%
0.62	1	< 0.1%
0.63	3	< 0.1%
0.65	1	< 0.1%
0.75	1	< 0.1%
0.99	1	< 0.1%

Value	Count	Frequency (%)
611.226	1	< 0.1%
611.136	1	< 0.1%
611.1	25	< 0.1%
611.1	7	< 0.1%
611.055	7	< 0.1%
611.0325	1	< 0.1%
611.01	1	< 0.1%
610.98	4	< 0.1%
610.92	4	< 0.1%
610.83	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	id	date	store_id	format	store_name	structure	division	deposit/distributor	state	municipality/city	supplier	grade	sku	sku_description	sku_category	sku_subcategory	units	unit_price	total
0	0	2016-01-01	2934	Grocery	Old Indigo BigCom	FORANEO	CENTRO	Vitena Vocals	Thrilvallor	Purple Creek	proveedor_2	IV	4533931	Cups Mango Peach	Super-flavour	Cereal box	0.45	21.5	9.675
1	15	2016-01-01	3098	AllInOne	Dead Burgundy Shop	DISTRIBUIDORES	CENTRO	Movitalf Empire	Alloralf	Long Chocolate Barrier	proveedor_2	IV	4533931	Cups Mango Peach	Super-flavour	Cereal box	15.75	21.5	338.625
2	19	2016-01-01	2026	AllInOne	Kicking Orange HairDresser	FORANEO	CENTRO-SUR	Gorngusco Toughworks	Lorgulgus	Horrible Purple Tree	proveedor_2	IV	4533931	Cups Mango Peach	Super-flavour	Cereal box	2.25	21.5	48.375
3	32	2016-01-01	2343	Leftorium	Funny Maroon LunchHall	FORANEO	CENTRO	Elortho Aerospace	Alloralf	Funny Magenta Tree	proveedor_2	IV	4533931	Cups Mango Peach	Super-flavour	Cereal box	0.90	21.5	19.350
4	64	2016-01-01	1533	Grocery	Defiant Red Mall	METRO	METRO-NORTE	Marvitrus Ifonforge Industries	Magornmar	Enlightened Dark Empire	proveedor_2	V	4533931	Cups Mango Peach	Super-flavour	Cereal box	4.50	21.5	96.750
5	107	2016-01-01	1225	Grocery	Short Navy Cafe	FORANEO	CENTRO-SUR	Erodmad Industrail	Egusgul	Clean Aqua Soil	proveedor_2	IV	4533931	Cups Mango Peach	Super-flavour	Cereal box	1.35	21.5	29.025
6	156	2016-01-01	2024	AllInOne	Alive Beige Grocery	FORANEO	SURESTE	Eioval Aerospace	Coalmar	Rare Orange Applepie	proveedor_2	VI	4533931	Cups Mango Peach	Super-flavour	Cereal box	0.45	21.5	9.675
7	160	2016-01-01	3820	GipsyTrade	Little Orchid Bank	METRO	METRO-SUR	Ioalfio Ifonforge Industries	Magornmar	Enlightened Dark Empire	proveedor_2	V	4533931	Cups Mango Peach	Super-flavour	Cereal box	0.90	21.5	19.350
8	173	2016-01-01	3694	Grocery	Kicking Beige SuperMarket	FORANEO	CENTRO-SUR	Gorngusco Toughworks	Lorgulgus	Horrible Purple Tree	proveedor_2	IV	4533931	Cups Mango Peach	Super-flavour	Cereal box	0.45	21.5	9.675
9	206	2016-01-01	2906	Grocery	Little Pink LunchHall	FORANEO	CENTRO	Elortho Aerospace	Alloralf	Funny Magenta Tree	proveedor_2	IV	4533931	Cups Mango Peach	Super-flavour	Cereal box	1.35	21.5	29.025

Last rows

	id	date	store_id	format	store_name	structure	division	deposit/distributor	state	municipality/city	supplier	grade	sku	sku_description	sku_category	sku_subcategory	units	unit_price	total
4254329	5489354	2017-06-04	118	Shop	First Azure Florist	FORANEO	PENÍNSULA	Alfthrilal Vocals	Mamoval	First Blue Rock	proveedor_1	VI	4829827	Golden Goals Chocolate Choc Chip	Sugar-free	Cereal bars	2.00	27.2	54.4
4254330	5489383	2017-06-04	253	Shop	Short Green Bank	FORANEO	PENÍNSULA	Valalar Aerospace	Egusco	Great Golden Applepie	proveedor_1	VI	4829827	Golden Goals Chocolate Choc Chip	Sugar-free	Cereal bars	0.50	27.2	13.6
4254331	5489398	2017-06-04	119	Shop	Dirty Lime SuperMarket	FORANEO	OCCIDENTE	Colorvit Ifonforge Industries	Nabargus	Old Sea Green Soil	proveedor_1	III	4829827	Golden Goals Chocolate Choc Chip	Sugar-free	Cereal bars	0.75	27.2	20.4
4254332	5489451	2017-06-04	117	Shop	Impressive Indigo Grocery	METRO	METRO-NORTE	Emolor Vocals	Alloralf	Horrible Chartreuse Mud	proveedor_1	IV	4829827	Golden Goals Chocolate Choc Chip	Sugar-free	Cereal bars	3.75	27.2	102.0
4254333	5489465	2017-06-04	254	Shop	Legendary Crimson TallMarket	FORANEO	CENTRO-SUR	Gorngusco Toughworks	Lorgulgus	Horrible Purple Tree	proveedor_1	IV	4829827	Golden Goals Chocolate Choc Chip	Sugar-free	Cereal bars	0.25	27.2	6.8
4254334	5489499	2017-06-04	121	Shop	Massive Purple HighShop	METRO	METRO-SUR	Thrilthoal Empire	Magornmar	Funny Lemon Star	proveedor_1	V	4829827	Golden Goals Chocolate Choc Chip	Sugar-free	Cereal bars	5.50	27.2	149.6
4254335	5489508	2017-06-04	251	Shop	Dirty Sky Blue BigCenter	FORANEO	BAJÍO	Lormarmad Corp.	Eemar	Legendary Lavender Key	proveedor_1	II	4829827	Golden Goals Chocolate Choc Chip	Sugar-free	Cereal bars	2.25	27.2	61.2
4254336	5489509	2017-06-04	125	Shop	Short Sky Blue TinyShop	FORANEO	NOROESTE	Lorealf Industrail	Valargorn	Tall Indigo Capital	proveedor_1	II	4829827	Golden Goals Chocolate Choc Chip	Sugar-free	Cereal bars	1.25	27.2	34.0
4254337	5489553	2017-06-04	120	Shop	Dead Sky Blue Grocery	FORANEO	SURESTE	Eioval Aerospace	Coalmar	Rare Orange Applepie	proveedor_1	VI	4829827	Golden Goals Chocolate Choc Chip	Sugar-free	Cereal bars	0.75	27.2	20.4
4254338	5489571	2017-06-04	9	Shop	Alive Purple Baker	DISTRIBUIDORES	SURESTE	Arbarrus Gmbh	Coalmar	Kicking Crimson Key	proveedor_1	VI	4829827	Golden Goals Chocolate Choc Chip	Sugar-free	Cereal bars	1.00	27.2	27.2

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart